/*
 Navicat Premium Data Transfer

 Source Server         : qq
 Source Server Type    : MySQL
 Source Server Version : 50548
 Source Host           : 123.206.120.163
 Source Database       : web_ods

 Target Server Type    : MySQL
 Target Server Version : 50548
 File Encoding         : utf-8

 Date: 12/19/2017 18:21:22 PM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `ods_node`
-- ----------------------------
DROP TABLE IF EXISTS `ods_node`;
CREATE TABLE `ods_node` (
  `node_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'èŠ‚ç‚¹id',
  `excel_name` varchar(64) NOT NULL COMMENT 'excel_name',
  `node_game` varchar(64) NOT NULL COMMENT 'æ¸¸æˆ',
  `node_activity_id` varchar(64) NOT NULL COMMENT 'æ´»åŠ¨id',
  `node_type` varchar(64) NOT NULL COMMENT 'nodeç±»åž‹',
  `node_size` varchar(64) NOT NULL COMMENT 'node size',
  `node_md5` varchar(64) NOT NULL COMMENT 'md5åŠ å¯†',
  `node_path` varchar(128) NOT NULL COMMENT 'èŠ‚ç‚¹è·¯å¾„',
  `xml_path` varchar(128) NOT NULL COMMENT 'xmlè·¯å¾„',
  `lua_path` varchar(128) NOT NULL COMMENT 'lua_path',
  `node_update_time` int(11) NOT NULL COMMENT 'æ›´æ–°æ—¶é—´',
  `node_update_user` varchar(64) NOT NULL COMMENT 'æ›´æ–°ç”¨æˆ·',
  `node_create_time` int(11) NOT NULL COMMENT 'åˆ›å»ºæ—¶é—´',
  `node_create_user` varchar(64) NOT NULL COMMENT 'åˆ›å»ºè€…',
  PRIMARY KEY (`node_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='æ–‡ä»¶èŠ‚ç‚¹è¡¨';

-- ----------------------------
--  Table structure for `ods_serverlist`
-- ----------------------------
DROP TABLE IF EXISTS `ods_serverlist`;
CREATE TABLE `ods_serverlist` (
  `s_id` int(11) NOT NULL AUTO_INCREMENT,
  `s_game` varchar(64) DEFAULT NULL,
  `s_platform` varchar(64) DEFAULT NULL,
  `s_ftpaddress` varchar(128) DEFAULT NULL,
  `s_ftpuser` varchar(64) DEFAULT NULL,
  `s_ftppwd` varchar(64) DEFAULT NULL,
  `s_filename` varchar(128) DEFAULT NULL,
  `s_serverlist` text,
  PRIMARY KEY (`s_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `ods_tags`
-- ----------------------------
DROP TABLE IF EXISTS `ods_tags`;
CREATE TABLE `ods_tags` (
  `t_id` int(11) NOT NULL AUTO_INCREMENT,
  `t_tag` varchar(128) DEFAULT NULL,
  `t_infos` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`t_id`),
  UNIQUE KEY `t_tag` (`t_tag`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `ods_tags`
-- ----------------------------
BEGIN;
INSERT INTO `ods_tags` VALUES ('5', 's1', '');
COMMIT;

-- ----------------------------
--  Table structure for `ods_user`
-- ----------------------------
DROP TABLE IF EXISTS `ods_user`;
CREATE TABLE `ods_user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户id',
  `user_name` varchar(64) NOT NULL COMMENT '用户登录名',
  `user_password` varchar(64) NOT NULL COMMENT '密码',
  `user_real_name` varchar(64) NOT NULL COMMENT '真实姓名',
  `user_role` tinyint(2) NOT NULL DEFAULT '0' COMMENT '0普通,1管理员',
  `user_games` varchar(512) NOT NULL COMMENT '用户权限组',
  `user_node` varchar(512) NOT NULL COMMENT '节点权限',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
--  Records of `ods_user`
-- ----------------------------
BEGIN;
INSERT INTO `ods_user` VALUES ('65', 'admin', 'e10adc3949ba59abbe56e057f20f883e', '管理员', '1', 'legend_h5,legend_h5_xyhl,XM_qiji,rxcqapp,qmby_boss_gj,foxtest,haifan_legend,guoan_legend,rxby,legend_h5_ydzf,legend_360,qjgjapp', '1001,1002,1003,1004,1005,10005,1006,1007,1008,1009,1010,1011', '1419579323');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
